Ques 131. Which of the following is not a feature of a cursor FOR loop?
1. Record type declaration. 2. Opening and parsing of SQL statements. 3. Fetches records from cursor. 4. Requires exit condition to be defined.
Is it helpful?
Add CommentView Comments
Ques 132. A developer would like to use referential datatype declaration on a variable. The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. How would the developer define this variable using referential datatypes?
1. Use employee.lname%type. 2. Use employee.lname%rowtype. 3. Look up datatype for EMPLOYEE column on LASTNAME table and use that. 4. Declare it to be type LONG.
Is it helpful?
Add CommentView Comments
Ques 133. Which three of the following are implicit cursor attributes?